/**
 * Copyright (c) 2010 BullionXpress.com,
 * Permission is hereby granted, free of charge, to any person obtaining
 * a copy of this software and associated documentation files (the
 * "Software"), to deal in the Software without restriction, including
 * without limitation the rights to use, copy, modify, merge, publish,
 * distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to
 * the following conditions:
 *
 * The above copyright notice and this permission notice shall be
 * included in all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
 * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
 * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
 * OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
 * WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 *
 */
package com.bullionxpress.server.impl;

import java.util.Timer;
import java.util.TimerTask;
import com.bullionxpress.server.application.ServerGlobals;
import com.bullionxpress.shared.util.Log;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 *
 * @author BullionXpress.com
 */
public class OrderExecutor {

    public OrderExecutor() {
        TimerTask task = new TimerTask() {

            public void run() {
                try {
                    ServerGlobals.getOrderManager().fill();
                    cleanUp();
                } catch (Exception ex) {
                    Log.info(ex);
                }
            }
        };
        Timer timer = new Timer();
        timer.scheduleAtFixedRate(task, 0, 1000);
    }

    public void cleanUp() {
        try {
            Connection conn = DatabaseManager.getConnection();
            Statement statement = null;
            try {
                statement = conn.createStatement();
                ResultSet r = statement.executeQuery("select distinct( accountid ) from positions where accountid in (select accountid from positions group by accountid having sum(units) = 0 );");
                while (r.next()) {
                    Statement stmt = conn.createStatement();
                    String id = r.getString("accountid");
                    stmt.executeUpdate("delete from positions where accountid = '" + id + "'");
                }
            } catch (Exception ex) {
                System.out.println(ex);
                ex.printStackTrace();
            }

        } catch (Exception ex) {
            Log.info(ex);
        }
    }
}
